﻿
CREATE PROCEDURE [dbo].[SYS_ServiceConfiguration_IsExist]
(
	@Service  varchar(50),
	@Type  varchar(500)
)

AS

DECLARE @TempId int

SELECT @TempId=[ConfigurationId] FROM dbo.[SYS_ServiceConfiguration] WHERE [Service]=@Service AND [Type]=@Type

IF @TempId IS NULL
	RETURN 0
ELSE
	RETURN 1

